<?php
// Test CVS

require_once 'Excel/reader.php';



// ExcelFile($filename, $encoding);
$data = new Spreadsheet_Excel_Reader();


// Set output Encoding.
$data->setOutputEncoding('CP1251');

/***
* if you want you can change 'iconv' to mb_convert_encoding:
* $data->setUTFEncoder('mb');
*
**/

/***
* By default rows & cols indeces start with 1
* For change initial index use:
* $data->setRowColOffset(0);
*
**/



/***
*  Some function for formatting output.
* $data->setDefaultFormat('%.2f');
* setDefaultFormat - set format for columns with unknown formatting
*
* $data->setColumnFormat(4, '%.3f');
* setColumnFormat - set format for column (apply only to number fields)
*
**/
set_time_limit (0);

session_start();
include_once('libs/db.php');

@MYSQL_CONNECT("localhost","root","krostyruso");
@mysql_select_db("operaciones");


$data->read('elementos.xls');

/*


 $data->sheets[0]['numRows'] - count rows
 $data->sheets[0]['numCols'] - count columns
 $data->sheets[0]['cells'][$i][$j] - data from $i-row $j-column

 $data->sheets[0]['cellsInfo'][$i][$j] - extended info about cell
    
    $data->sheets[0]['cellsInfo'][$i][$j]['type'] = "date" | "number" | "unknown"
        if 'type' == "unknown" - use 'raw' value, because  cell contain value with format '0.00';
    $data->sheets[0]['cellsInfo'][$i][$j]['raw'] = value if cell without format 
    $data->sheets[0]['cellsInfo'][$i][$j]['colspan'] 
    $data->sheets[0]['cellsInfo'][$i][$j]['rowspan'] 
*/

error_reporting(E_ALL ^ E_NOTICE);

for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {
	//for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
	//	echo "\"".$data->sheets[0]['cells'][$i][$j]."\",";
	//}
	//esto funciona con el indice unico por los 5 campos de codigo
	$query  = "INSERT INTO `elementos` (`id_elemento`, `codigo_unidad`, `codigo_b`, `codigo_c`, `codigo_d`, `codigo_extra`, `descripcion`, `update_st`, `update_ts`) VALUES
(0, '".$data->sheets[0]['cells'][$i][1]."', '".$data->sheets[0]['cells'][$i][2]."', '".$data->sheets[0]['cells'][$i][3]."', '".$data->sheets[0]['cells'][$i][4]."', '".$data->sheets[0]['cells'][$i][5]."', '".$data->sheets[0]['cells'][$i][7]."', 0, now());";
	echo $query;
	$result = @MYSQL_QUERY($query);
}


//print_r($data);
//print_r($data->formatRecords);
?>
